I am in the process of trying to create an electronic database for all of our members and their term dates. I am currently using Access. I am building one from scratch. We want to lower our paper usage down and make it easier to search old members. This database should list the members new and old contact information, what board they were appointed to, and term-limited information. I would like to add attendance by year in this database. I wanted to know if anyone was able to implement or create something for this? I need ideas. : )
A Database Usage for Council Boards, Commissions, and Committees
I would be interested in how you end up fulfilling this process. We need to move away from a paper-based member tracker, too - but this responsibility is fulfilled in another department, so I am hesitant to suggest replacing the system with an improved system unless I have one roughed out already.
I understand. In the city I am in, the Clerk of Council/City Clerk is in charge of maintaining records of all members and then relating it to the BCCs Secretaries.
I am in the process of looking into Accela Boards and Commissions software. It appears to be a good way of tracking. I don't know for sure because I have not tried. I only went through their webinar.